Open topic with navigation

> Retail / Data Migration / Adding dimensions

/  More

Adding dimensions

About adding dimensions

The next stage of the import process is to import the dimension details. For example, using the examples earlier in this document, the stock item JEAN1 may use 'Waist Size', 'Leg Length' and 'Colour' as dimensions.

This import is achieved using a CSVComma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file containing seven columns:

Product Group Code

1st Dimension Name

1st Dimension Set

2nd Dimension Name (optional)

2nd Dimension Set (optional)

3rd Dimension Name (optional)

3rd Dimension Set (optional)

For example:

JEAN1	Waist Size	Men's sizes	Leg Length	Long lengths	Colour	All Colours
SHIRT1	Neck Size	Men's sizes	Colour	Winter Colours
SKIRT1	Waist Size	Women's sizes	Colour	Summer Colours

Not all product groups have dimensions. Those product groups will not appear in the CSV file. For example, standard stock item product groups (such as DVD_RW1 listed in previous examples), do not appear in the table.

In some cases, the same dimensions are used for multiple product groups. In such a case, you must check if the dimension type already exists before you create it.

To import the dimension details

Open: Retail > Data Migration > Dimensions.

1. Enter the name of the CSVComma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file you want to import in the Source File box, or use the browse button to select the file.

2. To check the contents of the CSV file, click Validate.

   This checks that each line of data in the CSV file is correct. Any invalid data will be reported on-screen.

   To save the details as a text file by click Save Log once the data validation has finished.

3. To transfer the product group and stock data from your CSV file, click Import. This checks:

   • If the dimension already exists.

     If not, a new dimension record is created (RTLDimensionType).

   • If the dimension set exists in the dimension type.

     If not, a new dimension set is created (RTLDimensionSet).

   For each product group, this:

   1. Updates the product group record in the retail hierarchy (RTLPrdHierarchy) so that it is a product group with variants.
   2. Specifies the dimension/dimension set combinations that the product group will use by inserting a record into the variant structure (RTLVariantStructure).